﻿CREATE TABLE [core].[Image] (
    [ImageID]     INT          IDENTITY (1, 1) NOT NULL,
    [ImageTypeID] INT          NULL,
    [ImageData]   IMAGE        NULL,
    [CreatedBy]   VARCHAR (50) NULL,
    [CreatedDate] DATETIME     NULL,
    [UpdatedBy]   VARCHAR (50) NULL,
    [UpdatedDate] DATETIME     NULL,
    [EndDate]     DATETIME     NULL,
    CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ([ImageID] ASC),
    CONSTRAINT [FK_Image_Image] FOREIGN KEY ([ImageTypeID]) REFERENCES [core].[ImageType] ([ImageTypeID])
);

